Overview

Dataset statistics

Number of variables26
Number of observations292
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory72.0 KiB
Average record size in memory252.4 B

Variable types

NUM16
BOOL8
CAT1
DATE1

Reproduction

Analysis started2020-05-05 17:46:31.758032
Analysis finished2020-05-05 17:47:08.338689
Versionpandas-profiling v2.5.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml
udsventa has 59 (20.2%) zeros Zeros
udsprevisionempresa has 81 (27.7%) zeros Zeros
weekday has 41 (14.0%) zeros Zeros
sin_weekday has 41 (14.0%) zeros Zeros
roll4wd_udsventa has 50 (17.1%) zeros Zeros
roll4wd_udsstock has 17 (5.8%) zeros Zeros
udsprevisionempresa_shifted-1 has 82 (28.1%) zeros Zeros
udsprevisionempresa_shifted-2 has 83 (28.4%) zeros Zeros
udsstock_shifted7 has 7 (2.4%) zeros Zeros
roll4wd_udsstock_shifted1 has 18 (6.2%) zeros Zeros
roll4wd_udsstock_shifted7 has 24 (8.2%) zeros Zeros
udsventa_shifted1 has 59 (20.2%) zeros Zeros

Variables

fecha
Date

UNIFORM
UNIQUE
Distinct count292
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
Minimum2019-06-05 00:00:00
Maximum2020-03-22 00:00:00
Histogram

producto
Categorical

CONSTANT
REJECTED
Distinct count1
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
42
292
ValueCountFrequency (%) 
42 292 100.0%
 

Length

Max length2
Mean length2
Min length2
ValueCountFrequency (%) 
Decimal_Number 2 100.0%
 
ValueCountFrequency (%) 
Common 2 100.0%
 
ValueCountFrequency (%) 
ASCII 2 100.0%
 

udsstock
Real number (ℝ≥0)

Distinct count112
Unique (%)38.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean854.5056155579598
Minimum116.0
Maximum2209.0
Zeros0
Zeros (%)0.0%
Memory size2.4 KiB

Quantile statistics

Minimum116
5-th percentile355.95
Q1686.04
median799
Q31027
95-th percentile1394
Maximum2209
Range2093
Interquartile range (IQR)340.96

Descriptive statistics

Standard deviation329.1621247
Coefficient of variation (CV)0.3852076789
Kurtosis1.695097565
Mean854.5056156
Median Absolute Deviation (MAD)251.9917458
Skewness0.7364005654
Sum249515.6397
Variance108347.7044
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 116. 470. 682.02 687.02 762.12903226 ... 1026.60344828 1117.61111111 1122.61111111 1395. 2209. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
686.04 29 9.9%
 
1121.222222 14 4.8%
 
1026.206897 13 4.5%
 
762.2580645 13 4.5%
 
996.7931034 11 3.8%
 
836.6 11 3.8%
 
736 10 3.4%
 
765 7 2.4%
 
610 4 1.4%
 
862 4 1.4%
 
Other values (102) 176 60.3%
 
ValueCountFrequency (%) 
116 1 0.3%
 
135 2 0.7%
 
145 1 0.3%
 
174 1 0.3%
 
213 1 0.3%
 
ValueCountFrequency (%) 
2209 1 0.3%
 
1967 2 0.7%
 
1889 1 0.3%
 
1841 1 0.3%
 
1763 2 0.7%
 

udsventa
Real number (ℝ≥0)

ZEROS
Distinct count97
Unique (%)33.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean429.8904109589041
Minimum0.0
Maximum1830.0
Zeros59
Zeros (%)20.2%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1258
median457
Q3606.75
95-th percentile819
Maximum1830
Range1830
Interquartile range (IQR)348.75

Descriptive statistics

Standard deviation299.0282917
Coefficient of variation (CV)0.6955919091
Kurtosis2.375364375
Mean429.890411
Median Absolute Deviation (MAD)230.77538
Skewness0.6430750384
Sum125528
Variance89417.91922
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 44. 250.5 748.5 981. 1830. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 59 20.2%
 
546 8 2.7%
 
420 6 2.1%
 
487 6 2.1%
 
523 5 1.7%
 
280 5 1.7%
 
605 5 1.7%
 
701 5 1.7%
 
597 5 1.7%
 
479 5 1.7%
 
Other values (87) 183 62.7%
 
ValueCountFrequency (%) 
0 59 20.2%
 
88 1 0.3%
 
154 1 0.3%
 
177 2 0.7%
 
184 1 0.3%
 
ValueCountFrequency (%) 
1830 1 0.3%
 
1815 1 0.3%
 
1424 1 0.3%
 
1298 1 0.3%
 
1107 1 0.3%
 

udsprevisionempresa
Real number (ℝ≥0)

ZEROS
Distinct count200
Unique (%)68.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2021.8219178082193
Minimum0.0
Maximum15421.0
Zeros81
Zeros (%)27.7%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median1465.5
Q33152
95-th percentile5985.1
Maximum15421
Range15421
Interquartile range (IQR)3152

Descriptive statistics

Standard deviation2293.553084
Coefficient of variation (CV)1.134399159
Kurtosis6.782521316
Mean2021.821918
Median Absolute Deviation (MAD)1717.308313
Skewness2.00413952
Sum590372
Variance5260385.748
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 42.5 4049. 6620.5 15421. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 81 27.7%
 
3285 3 1.0%
 
1883 2 0.7%
 
1974 2 0.7%
 
5502 2 0.7%
 
2386 2 0.7%
 
88 2 0.7%
 
1263 2 0.7%
 
960 2 0.7%
 
369 2 0.7%
 
Other values (190) 192 65.8%
 
ValueCountFrequency (%) 
0 81 27.7%
 
85 1 0.3%
 
88 2 0.7%
 
134 1 0.3%
 
147 1 0.3%
 
ValueCountFrequency (%) 
15421 1 0.3%
 
13811 1 0.3%
 
12574 1 0.3%
 
8348 1 0.3%
 
8230 1 0.3%
 

promo
Boolean

Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
276
1
 
16
ValueCountFrequency (%) 
0 276 94.5%
 
1 16 5.5%
 

festivo
Boolean

Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
284
1
 
8
ValueCountFrequency (%) 
0 284 97.3%
 
1 8 2.7%
 

weekday
Real number (ℝ≥0)

ZEROS
Distinct count7
Unique (%)2.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.017123287671233
Minimum0
Maximum6
Zeros41
Zeros (%)14.0%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q11
median3
Q35
95-th percentile6
Maximum6
Range6
Interquartile range (IQR)4

Descriptive statistics

Standard deviation1.999067122
Coefficient of variation (CV)0.662573893
Kurtosis-1.24431598
Mean3.017123288
Median Absolute Deviation (MAD)1.711249765
Skewness-0.01071552041
Sum881
Variance3.996269359
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0. 0.5 5.5 6. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
6 42 14.4%
 
5 42 14.4%
 
4 42 14.4%
 
3 42 14.4%
 
2 42 14.4%
 
1 41 14.0%
 
0 41 14.0%
 
ValueCountFrequency (%) 
0 41 14.0%
 
1 41 14.0%
 
2 42 14.4%
 
3 42 14.4%
 
4 42 14.4%
 
ValueCountFrequency (%) 
6 42 14.4%
 
5 42 14.4%
 
4 42 14.4%
 
3 42 14.4%
 
2 42 14.4%
 

working_day
Boolean

Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size420.0 B
True
242
False
50
ValueCountFrequency (%) 
True 242 82.9%
 
False 50 17.1%
 

sin_weekday
Real number (ℝ)

ZEROS
Distinct count7
Unique (%)2.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-0.002677505076945293
Minimum-0.9749279121818236
Maximum0.9749279121818236
Zeros41
Zeros (%)14.0%
Memory size2.4 KiB

Quantile statistics

Minimum-0.9749279122
5-th percentile-0.9749279122
Q1-0.7818314825
median0
Q30.7818314825
95-th percentile0.9749279122
Maximum0.9749279122
Range1.949855824
Interquartile range (IQR)1.563662965

Descriptive statistics

Standard deviation0.7092579884
Coefficient of variation (CV)-264.895105
Kurtosis-1.507989269
Mean-0.002677505077
Median Absolute Deviation (MAD)0.6278742875
Skewness0.006768729133
Sum-0.7818314825
Variance0.5030468941
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[-0.97492791 -0.8783797 0.8783797 0.97492791], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
-0.4338837391 42 14.4%
 
0.4338837391 42 14.4%
 
-0.9749279122 42 14.4%
 
-0.7818314825 42 14.4%
 
0.9749279122 42 14.4%
 
0.7818314825 41 14.0%
 
0 41 14.0%
 
ValueCountFrequency (%) 
-0.9749279122 42 14.4%
 
-0.7818314825 42 14.4%
 
-0.4338837391 42 14.4%
 
0 41 14.0%
 
0.4338837391 42 14.4%
 
ValueCountFrequency (%) 
0.9749279122 42 14.4%
 
0.7818314825 41 14.0%
 
0.4338837391 42 14.4%
 
0 41 14.0%
 
-0.4338837391 42 14.4%
 

cos_weekday
Real number (ℝ)

Distinct count7
Unique (%)2.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-0.005559896581708024
Minimum-0.9009688679024191
Maximum1.0
Zeros0
Zeros (%)0.0%
Memory size2.4 KiB

Quantile statistics

Minimum-0.9009688679
5-th percentile-0.9009688679
Q1-0.9009688679
median-0.222520934
Q30.6234898019
95-th percentile1
Maximum1
Range1.900968868
Interquartile range (IQR)1.52445867

Descriptive statistics

Standard deviation0.7073551581
Coefficient of variation (CV)-127.2245172
Kurtosis-1.502452694
Mean-0.005559896582
Median Absolute Deviation (MAD)0.6399937036
Skewness0.01159750905
Sum-1.623489802
Variance0.5003513197
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[-0.90096887 -0.90096887 1. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
-0.222520934 42 14.4%
 
-0.222520934 42 14.4%
 
-0.9009688679 42 14.4%
 
-0.9009688679 42 14.4%
 
0.6234898019 42 14.4%
 
0.6234898019 41 14.0%
 
1 41 14.0%
 
ValueCountFrequency (%) 
-0.9009688679 42 14.4%
 
-0.9009688679 42 14.4%
 
-0.222520934 42 14.4%
 
-0.222520934 42 14.4%
 
0.6234898019 42 14.4%
 
ValueCountFrequency (%) 
1 41 14.0%
 
0.6234898019 41 14.0%
 
0.6234898019 42 14.4%
 
-0.222520934 42 14.4%
 
-0.222520934 42 14.4%
 

is_august
Boolean

Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
261
1
 
31
ValueCountFrequency (%) 
0 261 89.4%
 
1 31 10.6%
 

spring
Boolean

Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
291
1
 
1
ValueCountFrequency (%) 
0 291 99.7%
 
1 1 0.3%
 

summer
Boolean

Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
184
1
108
ValueCountFrequency (%) 
0 184 63.0%
 
1 108 37.0%
 

autumn
Boolean

Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
202
1
90
ValueCountFrequency (%) 
0 202 69.2%
 
1 90 30.8%
 

winter
Boolean

Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
200
1
92
ValueCountFrequency (%) 
0 200 68.5%
 
1 92 31.5%
 

roll4wd_udsventa
Real number (ℝ≥0)

ZEROS
Distinct count236
Unique (%)80.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean446.08579990215264
Minimum0.0
Maximum1387.0
Zeros50
Zeros (%)17.1%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1331.3
median497.0089286
Q3605.3125
95-th percentile763.35625
Maximum1387
Range1387
Interquartile range (IQR)274.0125

Descriptive statistics

Standard deviation252.0301914
Coefficient of variation (CV)0.5649814261
Kurtosis0.3518852621
Mean446.0857999
Median Absolute Deviation (MAD)194.8793279
Skewness-0.2677458333
Sum130257.0536
Variance63519.21737
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 134.3125 268.875 695.125 777.1875 1387. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 50 17.1%
 
682.125 2 0.7%
 
555 2 0.7%
 
347.375 2 0.7%
 
583.5 2 0.7%
 
491.25 2 0.7%
 
608.375 2 0.7%
 
414.5 2 0.7%
 
509.5 1 0.3%
 
388.75 1 0.3%
 
Other values (226) 226 77.4%
 
ValueCountFrequency (%) 
0 50 17.1%
 
268.625 1 0.3%
 
269.125 1 0.3%
 
276.5 1 0.3%
 
282.625 1 0.3%
 
ValueCountFrequency (%) 
1387 1 0.3%
 
1225.714286 1 0.3%
 
1026.428571 1 0.3%
 
1023.625 1 0.3%
 
924 1 0.3%
 

roll4wd_udsstock
Real number (ℝ≥0)

ZEROS
Distinct count237
Unique (%)81.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean798.5207681017612
Minimum0.0
Maximum2209.0
Zeros17
Zeros (%)5.8%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1601.625
median791.625
Q31014.6875
95-th percentile1352.978571
Maximum2209
Range2209
Interquartile range (IQR)413.0625

Descriptive statistics

Standard deviation359.2299086
Coefficient of variation (CV)0.4498692118
Kurtosis1.138346394
Mean798.5207681
Median Absolute Deviation (MAD)270.0410243
Skewness0.150376201
Sum233168.0643
Variance129046.1272
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 117.375 326.75 624.05 898.425 1383. 2209. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 17 5.8%
 
407 6 2.1%
 
504 5 1.7%
 
765 4 1.4%
 
1085 3 1.0%
 
1269 2 0.7%
 
666.25 2 0.7%
 
815.8 2 0.7%
 
1095 2 0.7%
 
513 2 0.7%
 
Other values (227) 247 84.6%
 
ValueCountFrequency (%) 
0 17 5.8%
 
234.75 1 0.3%
 
283.25 1 0.3%
 
324.5 1 0.3%
 
329 1 0.3%
 
ValueCountFrequency (%) 
2209 1 0.3%
 
2029.75 1 0.3%
 
1850.5 1 0.3%
 
1676 1 0.3%
 
1671.25 1 0.3%
 

udsprevisionempresa_shifted-1
Real number (ℝ≥0)

ZEROS
Distinct count199
Unique (%)68.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1978.7602739726028
Minimum0.0
Maximum15421.0
Zeros82
Zeros (%)28.1%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median1459.5
Q33129.5
95-th percentile5894.5
Maximum15421
Range15421
Interquartile range (IQR)3129.5

Descriptive statistics

Standard deviation2211.318974
Coefficient of variation (CV)1.117527476
Kurtosis6.658288573
Mean1978.760274
Median Absolute Deviation (MAD)1679.680053
Skewness1.916352236
Sum577798
Variance4889931.606
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 42.5 4049. 6147. 8289. 15421. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 82 28.1%
 
3285 3 1.0%
 
1883 2 0.7%
 
1974 2 0.7%
 
5502 2 0.7%
 
88 2 0.7%
 
2386 2 0.7%
 
1263 2 0.7%
 
960 2 0.7%
 
369 2 0.7%
 
Other values (189) 191 65.4%
 
ValueCountFrequency (%) 
0 82 28.1%
 
85 1 0.3%
 
88 2 0.7%
 
134 1 0.3%
 
147 1 0.3%
 
ValueCountFrequency (%) 
15421 1 0.3%
 
13811 1 0.3%
 
8348 1 0.3%
 
8230 1 0.3%
 
8171 1 0.3%
 

udsprevisionempresa_shifted-2
Real number (ℝ≥0)

ZEROS
Distinct count198
Unique (%)67.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1925.9486301369864
Minimum0.0
Maximum13811.0
Zeros83
Zeros (%)28.4%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median1457
Q33112.5
95-th percentile5802.25
Maximum13811
Range13811
Interquartile range (IQR)3112.5

Descriptive statistics

Standard deviation2068.730849
Coefficient of variation (CV)1.074136048
Kurtosis3.515810941
Mean1925.94863
Median Absolute Deviation (MAD)1630.802496
Skewness1.465369453
Sum562377
Variance4279647.327
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 42.5 4049. 6147. 8289. 13811. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 83 28.4%
 
3285 3 1.0%
 
88 2 0.7%
 
4752 2 0.7%
 
1974 2 0.7%
 
1263 2 0.7%
 
206 2 0.7%
 
369 2 0.7%
 
1883 2 0.7%
 
960 2 0.7%
 
Other values (188) 190 65.1%
 
ValueCountFrequency (%) 
0 83 28.4%
 
85 1 0.3%
 
88 2 0.7%
 
134 1 0.3%
 
147 1 0.3%
 
ValueCountFrequency (%) 
13811 1 0.3%
 
8348 1 0.3%
 
8230 1 0.3%
 
8171 1 0.3%
 
7675 1 0.3%
 

udsstock_shifted1
Real number (ℝ≥0)

Distinct count113
Unique (%)38.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean847.7693141880967
Minimum0.0
Maximum2209.0
Zeros1
Zeros (%)0.3%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile329
Q1684.03
median794
Q31026.405172
95-th percentile1380.05
Maximum2209
Range2209
Interquartile range (IQR)342.3751724

Descriptive statistics

Standard deviation326.4327012
Coefficient of variation (CV)0.38504897
Kurtosis1.595785844
Mean847.7693142
Median Absolute Deviation (MAD)250.3818133
Skewness0.6183419361
Sum247548.6397
Variance106558.3084
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 470. 682.02 687.02 762.12903226 ... 1026.60344828 1117.61111111 1122.61111111 1395. 2209. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
686.04 29 9.9%
 
1121.222222 14 4.8%
 
1026.206897 13 4.5%
 
762.2580645 13 4.5%
 
836.6 11 3.8%
 
996.7931034 11 3.8%
 
736 10 3.4%
 
765 7 2.4%
 
610 4 1.4%
 
484 4 1.4%
 
Other values (103) 176 60.3%
 
ValueCountFrequency (%) 
0 1 0.3%
 
116 1 0.3%
 
135 2 0.7%
 
145 1 0.3%
 
174 1 0.3%
 
ValueCountFrequency (%) 
2209 1 0.3%
 
1967 1 0.3%
 
1889 1 0.3%
 
1841 1 0.3%
 
1763 2 0.7%
 

udsstock_shifted7
Real number (ℝ≥0)

ZEROS
Distinct count112
Unique (%)38.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean825.6799136364945
Minimum0.0
Maximum2209.0
Zeros7
Zeros (%)2.4%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile247.5
Q1668
median765
Q31026.206897
95-th percentile1370.5
Maximum2209
Range2209
Interquartile range (IQR)358.2068966

Descriptive statistics

Standard deviation340.5828314
Coefficient of variation (CV)0.4124877277
Kurtosis1.320730838
Mean825.6799136
Median Absolute Deviation (MAD)259.505548
Skewness0.2945765599
Sum241098.5348
Variance115996.6651
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 470. 682.02 687.02 762.12903226 ... 1026.60344828 1117.61111111 1122.61111111 1395. 2209. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
686.04 28 9.6%
 
1121.222222 14 4.8%
 
1026.206897 12 4.1%
 
762.2580645 12 4.1%
 
996.7931034 11 3.8%
 
736 10 3.4%
 
836.6 10 3.4%
 
0 7 2.4%
 
765 7 2.4%
 
940 4 1.4%
 
Other values (102) 177 60.6%
 
ValueCountFrequency (%) 
0 7 2.4%
 
116 1 0.3%
 
135 2 0.7%
 
145 1 0.3%
 
174 1 0.3%
 
ValueCountFrequency (%) 
2209 1 0.3%
 
1889 1 0.3%
 
1841 1 0.3%
 
1763 2 0.7%
 
1657 1 0.3%
 

roll4wd_udsstock_shifted1
Real number (ℝ≥0)

ZEROS
Distinct count236
Unique (%)80.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean794.2741927592955
Minimum0.0
Maximum2209.0
Zeros18
Zeros (%)6.2%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1598.78125
median790.7625
Q31011.741071
95-th percentile1352.978571
Maximum2209
Range2209
Interquartile range (IQR)412.9598214

Descriptive statistics

Standard deviation361.3162686
Coefficient of variation (CV)0.4549011813
Kurtosis1.124549163
Mean794.2741928
Median Absolute Deviation (MAD)271.1079225
Skewness0.1396285914
Sum231928.0643
Variance130549.4459
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 117.375 326.75 624.05 898.425 1383. 2209. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 18 6.2%
 
407 6 2.1%
 
504 5 1.7%
 
765 4 1.4%
 
1085 3 1.0%
 
678 2 0.7%
 
769.4285714 2 0.7%
 
790.4 2 0.7%
 
601.625 2 0.7%
 
604.6 2 0.7%
 
Other values (226) 246 84.2%
 
ValueCountFrequency (%) 
0 18 6.2%
 
234.75 1 0.3%
 
283.25 1 0.3%
 
324.5 1 0.3%
 
329 1 0.3%
 
ValueCountFrequency (%) 
2209 1 0.3%
 
2029.75 1 0.3%
 
1850.5 1 0.3%
 
1676 1 0.3%
 
1671.25 1 0.3%
 

roll4wd_udsstock_shifted7
Real number (ℝ≥0)

ZEROS
Distinct count231
Unique (%)79.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean777.4713307240704
Minimum0.0
Maximum2209.0
Zeros24
Zeros (%)8.2%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1571.5357143
median782.25
Q31010.392857
95-th percentile1352.978571
Maximum2209
Range2209
Interquartile range (IQR)438.8571429

Descriptive statistics

Standard deviation377.5846166
Coefficient of variation (CV)0.4856572863
Kurtosis0.862584561
Mean777.4713307
Median Absolute Deviation (MAD)283.9763223
Skewness0.06369340259
Sum227021.6286
Variance142570.1427
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 117.375 326.75 624.05 898.425 1383. 2209. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 24 8.2%
 
407 6 2.1%
 
504 5 1.7%
 
765 4 1.4%
 
1085 3 1.0%
 
876.5 2 0.7%
 
416 2 0.7%
 
790.4 2 0.7%
 
769.4285714 2 0.7%
 
601.625 2 0.7%
 
Other values (221) 240 82.2%
 
ValueCountFrequency (%) 
0 24 8.2%
 
234.75 1 0.3%
 
283.25 1 0.3%
 
324.5 1 0.3%
 
329 1 0.3%
 
ValueCountFrequency (%) 
2209 1 0.3%
 
2029.75 1 0.3%
 
1850.5 1 0.3%
 
1676 1 0.3%
 
1671.25 1 0.3%
 

udsventa_shifted1
Real number (ℝ≥0)

ZEROS
Distinct count97
Unique (%)33.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean429.8904109589041
Minimum0.0
Maximum1830.0
Zeros59
Zeros (%)20.2%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1258
median457
Q3606.75
95-th percentile819
Maximum1830
Range1830
Interquartile range (IQR)348.75

Descriptive statistics

Standard deviation299.0282917
Coefficient of variation (CV)0.6955919091
Kurtosis2.375364375
Mean429.890411
Median Absolute Deviation (MAD)230.77538
Skewness0.6430750384
Sum125528
Variance89417.91922
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 44. 250.5 748.5 981. 1830. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 59 20.2%
 
546 8 2.7%
 
420 6 2.1%
 
487 6 2.1%
 
280 5 1.7%
 
605 5 1.7%
 
701 5 1.7%
 
523 5 1.7%
 
597 5 1.7%
 
479 5 1.7%
 
Other values (87) 183 62.7%
 
ValueCountFrequency (%) 
0 59 20.2%
 
88 1 0.3%
 
154 1 0.3%
 
177 2 0.7%
 
184 1 0.3%
 
ValueCountFrequency (%) 
1830 1 0.3%
 
1815 1 0.3%
 
1424 1 0.3%
 
1298 1 0.3%
 
1107 1 0.3%
 

roll4_udstock_shifted1
Real number (ℝ≥0)

Distinct count268
Unique (%)91.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean839.9594902289901
Minimum0.0
Maximum1772.63
Zeros1
Zeros (%)0.3%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile497.5559758
Q1728.5
median822.5638181
Q3963.5837931
95-th percentile1212.554583
Maximum1772.63
Range1772.63
Interquartile range (IQR)235.0837931

Descriptive statistics

Standard deviation226.4863712
Coefficient of variation (CV)0.269639636
Kurtosis2.041710673
Mean839.9594902
Median Absolute Deviation (MAD)165.7847578
Skewness0.3475181372
Sum245268.1711
Variance51296.07636
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 467.10406404 707.8125 1007.40719349 1008.65719349 1253.4375 1772.63 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1008.286609 6 2.1%
 
888.0774713 6 2.1%
 
749.9650358 4 1.4%
 
733.4417742 4 1.4%
 
1003.352778 4 1.4%
 
813.6026363 3 1.0%
 
918.4339822 2 0.7%
 
803 2 0.7%
 
995.25 2 0.7%
 
191.25 1 0.3%
 
Other values (258) 258 88.4%
 
ValueCountFrequency (%) 
0 1 0.3%
 
191.25 1 0.3%
 
295.25 1 0.3%
 
306.25 1 0.3%
 
309.5 1 0.3%
 
ValueCountFrequency (%) 
1772.63 1 0.3%
 
1558.375 1 0.3%
 
1535.75 1 0.3%
 
1493.375 1 0.3%
 
1472.375 1 0.3%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Missing values

Sample

First rows

fechaproductoudsstockudsventaudsprevisionempresapromofestivoweekdayworking_daysin_weekdaycos_weekdayis_augustspringsummerautumnwinterroll4wd_udsventaroll4wd_udsstockudsprevisionempresa_shifted-1udsprevisionempresa_shifted-2udsstock_shifted1udsstock_shifted7roll4wd_udsstock_shifted1roll4wd_udsstock_shifted7udsventa_shifted1roll4_udstock_shifted1
02019-06-0542765.000000523.012574.00.00.02True0.974928-0.22252100100523.00765.0015421.013811.00.0000000.0000000.000.00.00.000000
12019-06-06421026.206897752.015421.00.00.03True0.433884-0.90096900100752.000.0013811.05558.0765.0000000.000000765.000.0523.0191.250000
22019-06-0742996.793103383.013811.00.00.04True-0.433884-0.90096900100383.000.005558.00.01026.2068970.0000000.000.0752.0474.458128
32019-06-08421121.222222553.05558.00.00.05True-0.974928-0.22252100100553.000.000.04591.0996.7931030.0000000.000.0383.0796.301724
42019-06-0942686.0400000.00.00.00.06False-0.7818310.623490001000.000.004591.03404.01121.2222220.0000000.000.0553.0994.402778
52019-06-1042686.040000420.04591.00.00.00True0.0000001.00000000100420.000.003404.01797.0686.0400000.0000000.000.00.01008.286609
62019-06-1142649.000000287.03404.00.00.01True0.7818310.62349000100287.00649.001797.02554.0686.0400000.0000000.000.0420.0888.077471
72019-06-12421298.000000560.01797.00.00.02True0.974928-0.22252100100532.25898.252554.03809.0649.000000765.000000649.00765.0287.0735.807778
82019-06-13421153.000000686.02554.00.00.03True0.433884-0.90096900100735.501153.003809.01629.01298.0000001026.206897898.250.0560.0748.645000
92019-06-14421037.0000001830.03809.01.00.04True-0.433884-0.90096900100744.751037.001629.00.01153.000000996.7931031153.000.0686.0960.005000

Last rows

fechaproductoudsstockudsventaudsprevisionempresapromofestivoweekdayworking_daysin_weekdaycos_weekdayis_augustspringsummerautumnwinterroll4wd_udsventaroll4wd_udsstockudsprevisionempresa_shifted-1udsprevisionempresa_shifted-2udsstock_shifted1udsstock_shifted7roll4wd_udsstock_shifted1roll4wd_udsstock_shifted7udsventa_shifted1roll4_udstock_shifted1
2822020-03-1342996.7931031298.05827.00.00.04True-0.433884-0.90096900001711.625000571.0000000.00.01026.206897996.793103678.000000670.500000280.0912.880862
2832020-03-1442610.0000001424.00.00.00.05True-0.974928-0.22252100001571.500000966.2500000.01160.0996.7931031121.222222571.0000001085.0000001298.0951.526724
2842020-03-1542686.0400000.00.00.00.06False-0.7818310.623490000010.000000513.0000001160.01254.0610.000000686.040000966.250000513.0000001424.0939.450000
2852020-03-1642686.040000265.01160.00.00.00True0.0000001.00000000001391.750000505.7500001254.02825.0686.040000686.040000513.000000517.2857140.0816.578276
2862020-03-1742762.2580651107.01254.00.00.01True0.7818310.62349000001395.375000819.2857142825.02940.0686.0400001027.000000505.750000710.875000265.0696.369138
2872020-03-1842836.600000501.02825.00.00.02True0.974928-0.22252100001576.7500001055.5000002940.03062.0762.258065836.600000819.285714856.2857141107.0686.062258
2882020-03-19421026.206897405.02940.00.00.03True0.433884-0.90096900001468.000000678.0000003062.00.0836.6000001026.2068971055.500000678.000000501.0733.441774
2892020-03-20421172.0000000.03062.00.00.04True-0.433884-0.90096900001908.142857871.5000000.00.01026.206897996.793103678.000000571.000000405.0813.602636
2902020-03-21421967.0000000.00.00.00.05True-0.974928-0.22252100001896.714286976.4000000.00.01172.000000610.000000871.500000966.2500000.0940.334844
2912020-03-22421967.0000000.00.00.00.06False-0.7818310.623490010010.0000001240.0000000.00.01967.000000686.040000976.400000513.0000000.01174.777586